forum

home / developersection / forums / mysql inet_aton. did i find a bug or is this known?

Ask Question

MYSQL INET_ATON. Did I find a bug or is this known?

Lady Bird Johnson 2988 09-Jul-2013
Hi Developers,

Is this a known problem?

select * from 'tablename' where INET_ATON('any valid ip');
Shows the entire db. I accidentally forget to add ipaddress = INET_ATON('ip'); and cganged the entire db.

Thanks in advance. 
mysql mysql 
Updated on 09-Jul-2013
Lady Bird Johnson

Other

Follow
Can you answer this question?
Answer

1 Answers

AVADHESH PATEL

AVADHESH PATEL

09-Jul-2013
Hi Lady!

I don't see anything wrong with all rows returned. INET_ATON will return number > 0 if IP is valid OR NULL if IP is invalid. Which means, it's like issuing query

SELECT * FROM `tablename` WHERE 1
(or any other positive number) which will return all rows.

Thanks in advance.
advertising
advertising

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy